Platform Explorer / Nuxeo Platform LTS 2017 9.10

Component org.nuxeo.ecm.platform.routing.pageproviders

Contributions

XML Source

<?xml version="1.0"?>
<component name="org.nuxeo.ecm.platform.routing.pageproviders">

  <extension target="org.nuxeo.ecm.platform.query.api.PageProviderService"
    point="providers">

    <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ALL_ROUTE_MODELS">
      <pattern>
        SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState = 'validated'
      </pattern>
      <sort column="dc:title" ascending="true" />
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ROUTE_MODELS_WITH_TITLE">
      <pattern>
        SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState = 'validated' AND dc:title LIKE ?
      </pattern>
      <sort column="dc:title" ascending="true" />
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ALL_ROUTE_INSTANCES">
      <pattern>
        SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState =
        'running' AND dc:title LIKE ?
      </pattern>
      <sort column="dc:title" ascending="true" />
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="CURRENT_DOC_ROUTING_SEARCH_ATTACHED_DOC">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType != 'Folderish' AND
        ecm:currentLifeCycleState != 'deleted' AND dc:title ILIKE ?
      </pattern>
      <sort column="dc:title" ascending="true" />
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="SEARCH_ROUTE_BY_ATTACHED_DOC">
      <pattern>
        SELECT * FROM DocumentRoute WHERE (ecm:currentLifeCycleState = 'running'
        OR ecm:currentLifeCycleState = 'ready') AND docri:participatingDocuments/*
        IN (?)
      </pattern>
      <sort column="dc:title" ascending="true" />
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

  </extension>

</component>